package com.foreverwin.jzymes.common.mapper;

import com.foreverwin.jzymes.common.domain.CncReqLog;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface CncReqLogAdviceMapper {

    public List<CncReqLog> findCncReqLogByCreatedDate(@Param("site") String site, @Param("carrier") String carrier, @Param("resource") String resource, @Param("date") Date date );

    public List<CncReqLog> findCncReqLogBySendDate( @Param("site") String site, @Param("resource")String resource, @Param("date") Date date );

    public List<Map<String,Object>> countCncYieldByDateRange( @Param( "site" ) String site, @Param("startDate") Date startDate, @Param("endDate") Date endDate );

    public Map<String,Object> countCncYield( @Param( "site" ) String site, @Param( "resrce" ) String resrce, @Param("startDate") Date startDate, @Param("endDate") Date endDate );
}
